Financial Modeling in Excel For Dummies by Fairhurst Danielle Stein

Author:Fairhurst, Danielle Stein [Fairhurst, Danielle Stein]
Language: eng
Format: epub
ISBN: 9781119357551
Publisher: Wiley
Published: 2017-04-11T04:00:00+00:00

FIGURE 7-21: The completed five-year strategic forecast.

IF

The IF function is very commonly used in financial models because it allows you to test certain conditions in your model and change outcomes or results depending on what the user inserts into the model. It’s especially useful when building scenarios, because you can build the model so that the user can turn certain conditions on and off.

Type =IF and then use the Ctrl+A shortcut. The IF Function Arguments dialog box appears. There are three fields you need to fill in:

The logical statement that is evaluated: For example, is the weather sunny today? The answer to this will either be true or false.

The result if the statement is true: In this case, it might be “Go to the beach.”

The result if the statement is false: In this case, it might be “Stay home.”

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.